www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/ShopSys/ListDd/index.php
<?php require("../../class/connect.php"); require("../../class/db_sql.php"); require("../../class/q_functions.php"); require("../../class/user.php"); require "../".LoadLang("pub/fun.php"); $link=db_connect(); $empire=new mysqlquery(); $editor=1; //是否登陸 $user=islogin(); $page=(int)$_GET['page']; $start=0; $line=16;//每頁顯示條數 $page_line=18;//每頁顯示鏈接數 $offset=$page*$line;//總偏移量 $add=""; $search=''; $totalquery="select count(*) as total from {$dbtbpre}enewsshopdd where userid='$user[userid]'"; $query="select ddid,ddno,ddtime,userid,username,outproduct,haveprice,checked,truename,psid,psname,pstotal,alltotal,payfsid,payfsname,payby,alltotalfen,fp,fptotal from {$dbtbpre}enewsshopdd where userid='$user[userid]'"; //搜索 $sear=$_GET['sear']; if($sear) { $keyboard=RepPostVar($_GET['keyboard']); $add=" and ddno like '%$keyboard%'"; //時間 $starttime=RepPostVar($_GET['starttime']); $endtime=RepPostVar($_GET['endtime']); if($endtime!="") { $ostarttime=$starttime." 00:00:00"; $oendtime=$endtime." 23:59:59"; $add.=" and ddtime>='$ostarttime' and ddtime<='$oendtime'"; } $search="&sear=1&keyboard=$keyboard&starttime=$starttime&endtime=$endtime"; } $totalquery.=$add; $num=$empire->gettotal($totalquery);//取得總條數 $query.=$add; $query=$query." order by ddid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page1($num,$line,$page_line,$start,$page,$search); //導入模板 require(ECMS_PATH.'e/template/ShopSys/ListDd.php'); db_close(); $empire=null; ?>